How to: Convert imported Word text to columns in Excel.
Solution:
Copy the selected text to an Excel worksheet by using the 'Convert Text to Columns' command in the 'Data' menu.
1) Copy desired text in Word.
2) Switch to Excel.
3) Paste the text in the worksheet.
4) Select the cell with the text to be converted.
5) Select the 'Data' menu and select 'Text To Columns...'. (The Convert Text to Columns Wizard Step - 1 of 3 dialog box appears.)
a) Click 'Next' when selections in Step 1 of the Wizard have been made. (The Step 2 dialog box appears.)
b) Click 'Next' when selections in Step 2 of the Wizard have been made. (The Step 3 dialog box appears.)
c) Click 'Finish' when selections in Step 3 of the Wizard have been made. (The text is converted to columns.)
NOTE: The Wizard helps to specify how the text is distributed across columns. The converted data begins in the column being converted and then fills cells to the right unless a reference to a different location in the 'Destination' box (Wizard step #3) is entered.
